Subform filter did not have any affect on the main form due to design.
Cause:
The filter created on a subform only applies to the subform. This is by design of Microsoft Access.
Solution:
There is no workaround.
